A dynamic prompt dependency may return incorrect results if the "CONTAINS" or "LIKE" operator has been used in the dependency filter. Instead of returning all values for the dependent prompt variable that contain the specific string or are like the pattern of characters, the filter only returns those values that are equal to the dependency condition.

 WHERE  ( ORIG_VAR CONTAINS "ABCDEFG       " ) <===TRAILING BLANKS

The correct WHERE clause should be:

 WHERE  ( ORIG_VAR CONTAINS "ABCDEFG" )  <===NO TRAILING BLANKS

There is currently no circumvention for this problem.

Operating System and Release Information